I asked NZTA for data on the number of crashes each hour since 2000. Crashes are classified as Fatal, Serious injury, minor injury, and no injury.

Initially I am interested in understanding what the variations in the various ratios of crash types over time - and during holiday periods.

Is there any monthly signal in the percentage of crashes which are fatal?

Is there any signal in the percentage of crashes which result in a fatality or a serious injury?

What about if we remove non-injury crashes?

LS0tCnRpdGxlOiAiQ3Jhc2ggZGF0YSIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKSSBhc2tlZCBOWlRBIGZvciBkYXRhIG9uIHRoZSBudW1iZXIgb2YgY3Jhc2hlcyBlYWNoIGhvdXIgc2luY2UgMjAwMC4gQ3Jhc2hlcyBhcmUKY2xhc3NpZmllZCBhcyBGYXRhbCwgU2VyaW91cyBpbmp1cnksIG1pbm9yIGluanVyeSwgYW5kIG5vIGluanVyeS4KCkluaXRpYWxseSBJIGFtIGludGVyZXN0ZWQgaW4gdW5kZXJzdGFuZGluZyB3aGF0IHRoZSB2YXJpYXRpb25zIGluIHRoZSB2YXJpb3VzIHJhdGlvcwpvZiBjcmFzaCB0eXBlcyBvdmVyIHRpbWUgLSBhbmQgZHVyaW5nIGhvbGlkYXkgcGVyaW9kcy4KCmBgYHtyLCBpbmNsdWRlPUZ9CmxpYnJhcnkodGlkeXZlcnNlKQpsaWJyYXJ5KGdndGhlbWVzKQpsaWJyYXJ5KFJQb3N0Z3JlU1FMKQpsaWJyYXJ5KHpvbykKbGlicmFyeShsdWJyaWRhdGUpCmRiIDwtIGRiQ29ubmVjdChQb3N0Z3JlU1FMKCksIGRibmFtZT0nY3Jhc2hlcy0xOCcpCmBgYAoKYGBge3IsIGZpZy5oZWlnaHQ9MjB9CmNyYXNoZXMgPC0gdGJsKGRiLCAiY3Jhc2hlcyIpICU+JQogIGNvbGxlY3QoKSAlPiUKICBtdXRhdGUobW9udGggPSBhcy55ZWFybW9uKGRheSkpICU+JQogIGdyb3VwX2J5KG1vbnRoKSAlPiUKICBzdW1tYXJpc2UoZmF0YWxfYWxsID0gc3VtKGNvdW50W3NldmVyaXR5PT0iRmF0YWwiXSkvc3VtKGNvdW50KSoxMDAsCiAgICAgICAgICAgIGZhdGFsX2FsbF9pbmp1cnkgPSBzdW0gKGNvdW50W3NldmVyaXR5ICVpbiUgYygiRmF0YWwiKV0vc3VtKGNvdW50W3NldmVyaXR5ICE9ICJOb24taW5qdXJ5Il0pKjEwMCksCiAgICAgICAgICAgIGZhdGFsX3NlcmlvdXNfYWxsID0gc3VtIChjb3VudFtzZXZlcml0eSAlaW4lIGMoIkZhdGFsIiwgIlNlcmlvdXMiKV0vc3VtKGNvdW50KSoxMDApLAogICAgICAgICAgICBmYXRhbF9zZXJpb3VzX2luanVyeSA9IHN1bSAoY291bnRbc2V2ZXJpdHkgJWluJSBjKCJGYXRhbCIsICJTZXJpb3VzIildLwogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBzdW0oY291bnRbc2V2ZXJpdHkgIT0gIk5vbi1pbmp1cnkiXSkqMTAwKSkgJT4lCiAgbXV0YXRlKHllYXI9eWVhcihtb250aCkpCmBgYAoKSXMgdGhlcmUgYW55IG1vbnRobHkgc2lnbmFsIGluIHRoZSBwZXJjZW50YWdlIG9mIGNyYXNoZXMgd2hpY2ggYXJlIGZhdGFsPwoKYGBge3IsIGZpZy5oZWlnaHQ9MjB9CmdncGxvdChjcmFzaGVzLCBhZXMoeD1hcy5EYXRlKG1vbnRoKSx5PWZhdGFsX2FsbCkpICsKICBnZW9tX2NvbCgpICsKICBmYWNldF93cmFwKC4gfiB5ZWFyLCBuY29sPTIsIHNjYWxlcz0iZnJlZSIpCmBgYAoKSXMgdGhlcmUgYW55IHNpZ25hbCBpbiB0aGUgcGVyY2VudGFnZSBvZiBjcmFzaGVzIHdoaWNoIHJlc3VsdCBpbiBhIGZhdGFsaXR5IG9yIGEgc2VyaW91cyBpbmp1cnk/CgpgYGB7ciwgZmlnLmhlaWdodD0yMH0KZ2dwbG90KGNyYXNoZXMsIGFlcyh4PWFzLkRhdGUobW9udGgpLHk9ZmF0YWxfc2VyaW91c19hbGwpKSArCiAgZ2VvbV9jb2woKSArCiAgZmFjZXRfd3JhcCguIH4geWVhciwgbmNvbD0yLCBzY2FsZXM9ImZyZWUiKQpgYGAKCldoYXQgYWJvdXQgaWYgd2UgcmVtb3ZlIG5vbi1pbmp1cnkgY3Jhc2hlcz8KCmBgYHtyLCBmaWcuaGVpZ2h0PTIwfQpnZ3Bsb3QoY3Jhc2hlcywgYWVzKHg9YXMuRGF0ZShtb250aCkseT1mYXRhbF9zZXJpb3VzX2luanVyeSkpICsKICBnZW9tX2NvbCgpICsKICBmYWNldF93cmFwKC4gfiB5ZWFyLCBuY29sPTIsIHNjYWxlcz0iZnJlZSIpCmBgYA==